SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:3 WOODMORE DRIVE- Stylish, recently renovated home in a highly desirable neighborhood near Hanover, Dartmouth campus, local schools, and miles of walking, hiking, and cross-country trails. The interiors are spacious and bright, anchored by a large open-concept living room with a contemporary gas fireplace. The immaculate kitchen features a central island ideal for meal preparation, gathering, and casual dining, with an adjacent dining area complementing the space. On the east side of the main level just off the dining area is a large family room with a vaulted ceiling and skylight providing additional living space. The primary bedroom is situated on the west side of the main floor and includes an en suite bath, while two additional bedrooms on this level share a newer full bath. The lower level offers a spacious and versatile rec room or office area as well as a fourth bedroom with an en suite bath. Rounding out the floor is the laundry room that connects to a generous storage area, part of which is currently used as a home gym. The exterior spaces are equally appealing, a large south-facing deck with hillside views, a pergola, oversized hot tub, and ample garden space for entertaining or play. An attached carport accommodates two vehicles and includes a dedicated storage room, perfect for bikes, skis, and garden equipment. Ideally sited in a charming neighborhood with the convenience of all things Hanover at your fingertips, this beautifully updated and maintained home is turnkey and move-in ready. Exterior grass photos virtually enhanced. Showings begin Saturday, 4/4/26.
Description:A private 16+ acre setting with views of Mt. Ascutney, a pond, barn, and open land to explore make this Plainfield property a special Upper Valley retreat. This home was completedly renovated in 2019. Large windows throughout the home bring in natural light and take full advantage of the surrounding landscape. The main level features a primary suite with walk-in closet and a spacious bath with soaking Jacuzzi tub and separate shower. The kitchen is well equipped for both everyday living and entertaining, with quartz countertops, a Thor Professional gas range, and generous cabinet and storage space. The open kitchen, dining, and living area creates a comfortable central gathering space for family and friends. The finished lower level adds great additional living space with a custom bar, pool table area, office, and exercise room—ideal for entertaining, working from home, or relaxing at the end of the day. Outside, two decks offer inviting spaces for outdoor dining and gathering. Spend summer evenings enjoying the peaceful setting, relax in the hot tub under the stars, or gather around a fire by the pond. In winter, the pond becomes a perfect spot for skating. The property also includes a barn, chicken coop, greenhouse, 2 sheds, treehouse and open acreage to explore. A two-car garage plus additional garage space provides plenty of room for vehicles, equipment, workshop and hobbies. Located just 7 miles from I-89, the property offers an easy commute to all Upper Valley employment while maintaining the privacy and space of a rural setting.
Description:Looking for a property that truly has it all? Look no further than 376 Orford Road, in the coveted town of Lyme, NH. With 4,500 square feet of wonderfully comfortable and functional living space, the first floor offers a primary en suite bedroom, 2 additional bedrooms and bathrooms, a large living room, spacious eat-in kitchen, mudroom and laundry. The lower level includes a media room, recreation room, exercise room and office. Attached to the main residence, and with its own entrance as well, is a two story auxiliary dwelling unit equipped with a full eat-in kitchen, living room, laundry, 3/4 bathroom and private deck - ideal for in-laws, a nanny or rental opportunity. The back of the home connects to the level, landscaped, and fenced-in backyard area with a hot tub, in-ground pool, and pool house - ideal for relaxing or entertaining. The oversized 3 car garage has an upper level that could easily be finished off for additional living space, or is ideal "as is" for a home office or business storage. The abutting conserved land offers lovely pastoral views and westerly sunsets. Rounding out the property is another large outbuilding and separate shed for all your storage needs. Lyme is home to one of the most highly rated K - 8th grade schools in the state and is a short drive to Hanover, Dartmouth College and Dartmouth Health. Don't miss this incredible opportunity for a property that has everything you want, and more.
Description:ADAPTIVE REUSE OPPORTUNITY – 25 ACRE ORGANIC HOMESTEAD located within 2 hours of Boston! Welcome to the former home of the renowned D Acres Permaculture Farm & Educational Center. Cultivate a working farm, a restaurant, a family compound, an event or wedding venue. This property offers the space and soul to support an array of visions. The heart of the main building features a commercial kitchen with indoor and outdoor dining space. A network of beautiful rooms with mountain views on the second and third floors accommodate more than 15 guests at a time. This land has been lovingly shaped with intention – featuring orchards of mature fruit trees, perennial gardens, open fields, and natural systems designed for long-term abundance. Additional building sites with breathtaking mountain vistas offer extraordinary possibilities for expansion or subdivision. A rare sense of peace & privacy. Located within 30 minutes of I-93. A truly unique opportunity. This is what legacies are made of.
Description:Discover a quietly captivating Contemporary, where natural light pours in and the landscape becomes an ever-present part of the experience. Nearly every room frames a view, inviting you to slow down, settle in, and savor the setting. Thoughtfully designed gathering spaces offer both openness and intimacy. Host dinners in the formal dining room, linger over morning coffee in the breakfast nook, or curl up by the fire as the hillside shifts with the seasons. With generous proportions, the living areas adapt beautifully, whether entertaining, unwinding, or simply living with ease. For those who work from home, a full-size office with built-in bookshelves and expansive windows provides an inspiring place to spend your days. The kitchen is functional, crafted for those who love to cook and connect. A nearby pantry and direct-access mudroom streamline daily routines and arrivals. The east wing features three main-level bedrooms and two full baths, creating both comfort and flexibility. Upstairs, the primary suite feels like a private retreat; wrapped in windows on three sides, filled with soft light, and oriented toward serene northern views. A walk-in closet and full bath with a double vanity complete this sanctuary-like space. A full unfinished basement offers abundant storage, laundry, and direct outdoor access. Outside, rolling lawn, mature landscaping, a solar tracker, and apple trees blend seamlessly with the open field beyond.
Description:2 HILTON FIELD LANE- Uniquely positioned at the end of Occom Pond with views over the former Hanover Country Club and partial views of the water, Hilton Field Lane presents a rare and extraordinary opportunity to own in the highly coveted Rope Ferry neighborhood of downtown Hanover. The mostly level .7-acre parcel features a lovely mix of landscaping and statuesque mature trees as well as a swimming pool and cabana on the east side of the property. The original 1910 colonial home–officially listed as a 6-bedroom/7-bath–offers stately living and dining areas and gorgeous original details while the entire structure has been well-upgraded and expanded over the years. There is an ADU (accessory dwelling unit) on the lower level as well as rented living space on the east side with a well-established rental history. Reimagine the historic home in your own design or develop a new vision for this incredible lot and location all while enjoying a short walk to Hanover’s shopping and restaurants, Dartmouth campus, and miles of conserved land in Pine Park across the street. Architectural floor plans available.
Description:TAVERN LEDGE FARM- Privately situated in the highly coveted Tavern Lane neighborhood in Lyme, this stunningly immaculate property sits on 75 mixed acres with gorgeous south westerly views and sunsets. While enjoying pastoral quietude, it is still within minutes of the area’s finest schools, restaurants, shopping, and recreation including the Dartmouth Skiway and Post Pond. The expansive main residence is designed for both entertainment and peaceful retreat, with common spaces perfectly appointed to take in the view and landscaped grounds complemented by quiet nooks for cozy solitude. The main floor features an eat-in chef's kitchen adjoining a large screened porch, vaulted formal dining room and living room with central fieldstone fireplace, en suite bedroom, and a sophisticated den/office. On the second level is a grand primary suite with its own fireplace, balcony, sizable bath, and walk-in closets, while two additional bedrooms and baths, a versatile bonus room, and a rec room with cupola round out the level. Adjacent the home is a finished heated barn with a kitchen and bath, allowing for additional entertainment/living space, a home gym, or workshop. The conserved land component is comprised of miles of woods and trails for the outdoor enthusiast to enjoy in any season. With easy access to Hanover, Dartmouth College, Dartmouth Health, and myriad offerings throughout the Upper Valley, this spectacular bucolic retreat is second to none.